[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '154' >
2 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192 | 32.4519 | 1990-03-27 | Information Services | peter1@adventure-works.com | Peter Connelly | 310-555-0133 | 672243793 | Peter | M | 2018-12-23 | Connelly | adventure-works\peter1 | S | I | 154 | 2 | 310-555-0133 | | 54 | 2018-12-23 | Current | Network Administrator | 69 |
| 30 | 32.4519 | 1987-01-24 | Information Services | ashvini0@adventure-works.com | Ashvini Sharma | 656-555-0119 | 749389530 | Ashvini | M | 2018-10-03 | Sharma | adventure-works\ashvini0 | S | R | 154 | 2 | 656-555-0119 | | 55 | 2018-10-03 | Current | Network Administrator | 70 |
Generated 2024-04-28 21:23:21.543 UTC